package com.recruit.g1.resume.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.recruit.g1.pojo.resume.entity.Resume;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface ResumeMapper  extends BaseMapper<Resume> {

    @Insert("INSERT INTO resume (user_id, user_contact, name, qualification, experience, arrive_time, info_frame) VALUES (#{UserId},#{UserContact},#{name},#{qualification},#{experience},#{arriveTime},#{infoFrame})")
    int insert(Resume resume);

    @Select("select * from resume where id=#{id}")
    Resume selectById(Long id);

    @Delete("delete from resume where id=#{id}")
    int deleteById(Long id);

    @Select("select * from resume where user_id = #{id}")
    List<Resume> selectByUserId(Long id);
}
